﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderMemo_Insert]
(
	@ReturnOrderId  int,
	@Memo  nvarchar(4000),
	--@Published  bit,
	@CreatedBy int,
	@Id int OUTPUT
)

AS


INSERT INTO dbo.[OPM_ReturnOrderMemo]
(
	[ReturnOrderId],
	[Memo],
	[Published],
	[Deleted],
	[CreatedBy],
	[UpdatedBy],
	[CreatedOn],
	[UpdatedOn],
    [ROWGUID]
)
VALUES
(
	@ReturnOrderId,
	@Memo,
	1,
	0,
	@CreatedBy,
	@CreatedBy,
	getdate(),
	getdate(),
    newid()
)

SET @Id = SCOPE_IDENTITY();

--#endregion